UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y6WSQKTjZgb2Zp+hWyO3e+ipGaNG+7YAjrDmJlKqy5I='
WHERE
key_id = '0b7b78ee528ed1cc4d16be5de53fe64660d78ed9be9a91f6e06e3f1ee62641a3'
AND (
token = 'y6WSQKTjZgb2Zp+hWyO3e+ipGaNG+7YAjrDmJlKqy5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)