UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CT074zL4OBP2S3CLmz8HZbP8bE/TgyQcDi5kd7wuGwA='
WHERE
key_id = '16ab16b8c8283f4f6f6bb5b1cbc5a141941fe7685665a052c96671aaf15643a1'
AND (
token = 'CT074zL4OBP2S3CLmz8HZbP8bE/TgyQcDi5kd7wuGwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)