UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfJZZe+6TwYPro/peBDGEp6mL5l+QcdGcFfo9OeQLkM='
WHERE
key_id = '3b1250049316724069e4fc477e7ac86940ebe1c743be4026ef2489e5e208ce2a'
AND (
token = 'ZfJZZe+6TwYPro/peBDGEp6mL5l+QcdGcFfo9OeQLkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)