UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HflNB6OfYbs0VTgX+7EeI9G/YemqI+fi8hqe7tBaEMk='
WHERE
key_id = '5de7eef66b28136a0bc6e196b4a9f638ab019dd9bc826ff823cdf4c67f3f9207'
AND (
token = 'HflNB6OfYbs0VTgX+7EeI9G/YemqI+fi8hqe7tBaEMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)