UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nDXHAN0+7YnVqUCEGuo7H6SnI9hlZFtbq8kuCSyARBs='
WHERE
key_id = 'd2d8bd57dc9c3e40e03bcad930ea8c183762c72045a40505337a8c62b96a70e4'
AND (
token = 'nDXHAN0+7YnVqUCEGuo7H6SnI9hlZFtbq8kuCSyARBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)