UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8Lg7XWylHg1U3vjENf8v1BuLmRicIh8ccdYC2BE+4k='
WHERE
key_id = 'e37aa9ef1871751a312e91b911d6b9afd5706737d048cd1e24246d9167c67325'
AND (
token = 'z8Lg7XWylHg1U3vjENf8v1BuLmRicIh8ccdYC2BE+4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)