UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zn8feuTfoWEnyZRSYSYYgxAD0X2iSUbu5vkU/b7myCE='
WHERE
key_id = 'a1330b91c217742b194c6bb0498589ea4c01adfe9d0762f0b1a5a9ed4e36024e'
AND (
token = 'Zn8feuTfoWEnyZRSYSYYgxAD0X2iSUbu5vkU/b7myCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)