UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+OqJ0EscIJSGFKW2U7D8qD2xs3rK6TRc+MpHnVbFghE='
WHERE
key_id = 'bad1c81dc97285c1cc62632cd8d2020f3c1bfc7760233abe04df51b3897c5c8e'
AND (
token = '+OqJ0EscIJSGFKW2U7D8qD2xs3rK6TRc+MpHnVbFghE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)