UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXnXc2S6zoTJ5KCyzqCHGG5hkkA95RYcwem7i36LQ4E='
WHERE
key_id = '5bef3c75ae0d866069cf2218c39559de9c70c2a82ed799e053c298115ed6806f'
AND (
token = 'cXnXc2S6zoTJ5KCyzqCHGG5hkkA95RYcwem7i36LQ4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)