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