UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnZ4fOlWW4XHKHjQAZ7Uu1Dl89AE6tpeZqbWLxyoLt4='
WHERE
key_id = '8429ac7f644e724973af69e7c6809768fbfa391988860ed1ea17a23537b7424c'
AND (
token = 'KnZ4fOlWW4XHKHjQAZ7Uu1Dl89AE6tpeZqbWLxyoLt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)