UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4RY92ZtjZpaGFP2lc+EBIVzBBRpIxBnGN6kex8dKTTI='
WHERE
key_id = 'a727c4288e921b0042962dbe0d6061699e751e0bf48f7648432355f4161ebe1c'
AND (
token = '4RY92ZtjZpaGFP2lc+EBIVzBBRpIxBnGN6kex8dKTTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)