UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nji+PwxPDWCp8CFaGXv1qO77OiWnf4ryWjkP1fYTxAE='
WHERE
key_id = 'ffb80a2ef8346b4df57ee07fe228da4a53c368acae2bea4324ab94bb38390d1e'
AND (
token = 'Nji+PwxPDWCp8CFaGXv1qO77OiWnf4ryWjkP1fYTxAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)