UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKncofXu17If49fkZ//px5Q/JfwS721sEX7ZZTycnII='
WHERE
key_id = '30b67677cfbc266f1fc5ad7a4feb80a3f09122c4d58537014310ea4982606cda'
AND (
token = 'cKncofXu17If49fkZ//px5Q/JfwS721sEX7ZZTycnII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)