UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mKp9CvWeb0SsoAs+JPsLKk+XMX1HEEKm6v874SJCPss='
WHERE
key_id = 'ce3ed0b648f24fabc777a80d0635e0a7d5a8a83d799b6cd6b6bd7e01617169d6'
AND (
token = 'mKp9CvWeb0SsoAs+JPsLKk+XMX1HEEKm6v874SJCPss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)