UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BGgllOoHFovwwznY8fWhVNmRLwmOgCYehQGnM2LYoI='
WHERE
key_id = '2683e20afca183811cd95accb269e039662c189d14f510282e8fbfbe5f5aee9f'
AND (
token = '7BGgllOoHFovwwznY8fWhVNmRLwmOgCYehQGnM2LYoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)