UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kndF+P0cRX828jk5IIF2kpkfgi5eC9+hDbGKL6j686E='
WHERE
key_id = 'c9676e7503eb168e16662e3fb4bbfb66a4854a9eac404c121a2d81bafb07a2d5'
AND (
token = 'kndF+P0cRX828jk5IIF2kpkfgi5eC9+hDbGKL6j686E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)