UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/01qLHUZoDODxoTzbova1l+HVnECXF7yBoPLJJ9bOmc='
WHERE
key_id = '787b2b9a85ec1eae7868781ca29b0ae03f677f4485f7068125f210ee6d3b85da'
AND (
token = '/01qLHUZoDODxoTzbova1l+HVnECXF7yBoPLJJ9bOmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)