UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhC3zBwvwauBAoJAhRNaLy0feBY6ULFgxsmA+Ukk5J8='
WHERE
key_id = 'd111bb67ee23b0894e8f11a5c0c8a3cbebfa4b781a20fc0f2c6fd79d0a671c58'
AND (
token = 'NhC3zBwvwauBAoJAhRNaLy0feBY6ULFgxsmA+Ukk5J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)