UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XBsVYkRean9o7tyzw3k1cLDrlgP82w6OwCX7N9wHiw='
WHERE
key_id = '9f9833933486e8665132ff646e786a3f4b4070d224ef044cef1820e7aed23557'
AND (
token = '9XBsVYkRean9o7tyzw3k1cLDrlgP82w6OwCX7N9wHiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)