UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asaJGks4ZbAP+00pePSn+9NRrHJZymCI3ZKJO1fRUcM='
WHERE
key_id = 'd357894b72369aedc3b621b3adec57c4faec0d110f3c4c73675453fa6eff6797'
AND (
token = 'asaJGks4ZbAP+00pePSn+9NRrHJZymCI3ZKJO1fRUcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)