UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/qIWj/qLnBatyjAfhzsl/LHlw4C7f1qoCJrvLePxwHo='
WHERE
key_id = '9fd86b3a66ad423d6252cc610f26760556ff519ddade026480cd1dffc5cd79cc'
AND (
token = '/qIWj/qLnBatyjAfhzsl/LHlw4C7f1qoCJrvLePxwHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)