UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CwmPQAajlH0qGN2BHc9yFGngXmDo33YiySZ3gU6HEdo='
WHERE
key_id = '55788e8265be6e2e86d3229046bc31666811f5f18b873713e31edd73e84b1bf6'
AND (
token = 'CwmPQAajlH0qGN2BHc9yFGngXmDo33YiySZ3gU6HEdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)