UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhNUGIiLU9BgMLapmoKrByL8fIOu2DHWuuPoJXLz/LM='
WHERE
key_id = '050b99596a597f933461bf897344c1f21d9746f9a4eab94156042bb9cbb62660'
AND (
token = 'ZhNUGIiLU9BgMLapmoKrByL8fIOu2DHWuuPoJXLz/LM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)