UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zC31/Dw9ChUWyLmbnsOTIzAr/SsDV2qwtpyMAlTvZEk='
WHERE
key_id = 'e8c1f81270efee085316c120d9bbecfe8903e9b324ec0a2f758a384c7553161e'
AND (
token = 'zC31/Dw9ChUWyLmbnsOTIzAr/SsDV2qwtpyMAlTvZEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)