UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kZFNzH79KJwopzP5R6122t3hu81jK4PdgJkNVrXaYw='
WHERE
key_id = 'a9eafcdab1f695f791a8901234dc4118ad65f57d16969160073f4b91c7d264b2'
AND (
token = '9kZFNzH79KJwopzP5R6122t3hu81jK4PdgJkNVrXaYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)