UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCPZG1QQhY8g963C4nhxV3pmm4Rf6Mqo9WpswfaRJg8='
WHERE
key_id = '18ee99087e3ee6942205c2475e640a44b9f936933e6ba492d12d065689d997de'
AND (
token = 'lCPZG1QQhY8g963C4nhxV3pmm4Rf6Mqo9WpswfaRJg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)