UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ9v6hbeWt+fu7YchA+vMWu5TEGb+XCphlZZbBN0VOM='
WHERE
key_id = 'e30d36b97d919183a7f90de02f975f44b6c043bdf5ce7b04631444cb32dd7fe7'
AND (
token = 'zQ9v6hbeWt+fu7YchA+vMWu5TEGb+XCphlZZbBN0VOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)