UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBaQpAICde2GCVi7HBOeBqmhWjz0AMjDmdHVmy8iMJM='
WHERE
key_id = 'b77b280edfd240ab96638e8a762dfb5fea03743f63b63d6f9611ba09b0bd4a20'
AND (
token = 'QBaQpAICde2GCVi7HBOeBqmhWjz0AMjDmdHVmy8iMJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)