UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cA9Zo2PCl5gczddZ5C4OBYsywMi9+5h9DoRao7nH73I='
WHERE
key_id = 'ad7a62ca4735b890c48780f1dd24c5ecfb5ad0d10abe9778bac444b6b415a002'
AND (
token = 'cA9Zo2PCl5gczddZ5C4OBYsywMi9+5h9DoRao7nH73I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)