UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tL0vSyhiXJEhTqDrH3tpMw7YxX+jdF8aOnZJohLbsAY='
WHERE
key_id = '29ce701d5df6226f74552c1a07bf9028a0e79a2e4c42f5a5571665547fc86930'
AND (
token = 'tL0vSyhiXJEhTqDrH3tpMw7YxX+jdF8aOnZJohLbsAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)