UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8JONejhCpNLTNe0NVgGLP7vnkF3jRBJVN0h1+h80oU='
WHERE
key_id = '9cbfbb9f4469d451ff3df966fc3ef32e8e1f81aa1407ae29098d4c5cb64ec7dc'
AND (
token = 'Y8JONejhCpNLTNe0NVgGLP7vnkF3jRBJVN0h1+h80oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)