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