UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NZPbnYHARMM+6cYUPJ6Mq7e/tJioZsl2v+AI7W2TW6U='
WHERE
key_id = 'e8a603aaa17716a1e39a9665490f48237441f1b9a2e8c4884a3bb30ef9550bb2'
AND (
token = 'NZPbnYHARMM+6cYUPJ6Mq7e/tJioZsl2v+AI7W2TW6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)