UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QGKggzFq0hVfCnX+jM/+mF7dNcS00k/W8k8zSr91y0o='
WHERE
key_id = '7587b7badbcfe9e47481c630d3b5962c7d83174d7682b2a07f3491f5e0f7ebe9'
AND (
token = 'QGKggzFq0hVfCnX+jM/+mF7dNcS00k/W8k8zSr91y0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)