UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUSG9XmAPUlKrCSAlH8yiqFbF6vLSBquyOw474DcT04='
WHERE
key_id = '6cbacb02d29cc6678cf72f3389ab8fd5e70185f3e29913c0bc5793803ac7e33b'
AND (
token = 'nUSG9XmAPUlKrCSAlH8yiqFbF6vLSBquyOw474DcT04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)