UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '94cUEFG1ZN6GKrn7iEVt28GyyUNWAvKkIT3K3wTe8wY='
WHERE
key_id = '21123b562b36755a77775fee662e8ebc1bbf84e5c7603944dae0968ce72dfe03'
AND (
token = '94cUEFG1ZN6GKrn7iEVt28GyyUNWAvKkIT3K3wTe8wY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)