UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TVGwplDJQWUQlnnJNTegGVpStwbuTY5hzMnsXEyvQIw='
WHERE
key_id = '42116ed2886b1a5160630ed9c58c2529ebbea714da52038d7d1b76dddb971c7b'
AND (
token = 'TVGwplDJQWUQlnnJNTegGVpStwbuTY5hzMnsXEyvQIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)