UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kP3FDrBpz8QCUeAzfXNXwHruFVT2UCp9f4xdRng6R9k='
WHERE
key_id = 'c1cf82cbcd68f0ca611202cbdbf41bc64b878d06f06af06b9462ba08d7edb3ae'
AND (
token = 'kP3FDrBpz8QCUeAzfXNXwHruFVT2UCp9f4xdRng6R9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)