UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RHBvwFpUXwBha/JpPUxOj6BEEM+zu9W5Qt+uBZnYpPw='
WHERE
key_id = '7ebc46f65e473b98641a4e20e0910f03bc66a4ef38579f195c6cb4ab6491449e'
AND (
token = 'RHBvwFpUXwBha/JpPUxOj6BEEM+zu9W5Qt+uBZnYpPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)