UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Npv1Vy4oUhb12xMhn7CtW6OIt3pTpLRebYob490430='
WHERE
key_id = 'de80a2b7289f11296ec7ff97e79b0f6e3505a04defbf12d85ea803b34dd68f1b'
AND (
token = '1Npv1Vy4oUhb12xMhn7CtW6OIt3pTpLRebYob490430='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)