UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vt4JZPcMmUoUpB+1HnZ6BA6OGWF8fkdi62XRBYjB62k='
WHERE
key_id = '12ef2664c830ccde46c7b3eb644cfbea21f7c87036ab64da09ffd9aee82e937e'
AND (
token = 'Vt4JZPcMmUoUpB+1HnZ6BA6OGWF8fkdi62XRBYjB62k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)