UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A+afjkzJv5RK2HvCgDRp0NX/35kb8YFz9TZTXcwY6+4='
WHERE
key_id = 'd9b7b1395760e40bd859b3bd678d2d3e6df67dd429f9bac7654413ee8e3ca24a'
AND (
token = 'A+afjkzJv5RK2HvCgDRp0NX/35kb8YFz9TZTXcwY6+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)