UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6N6O0gk+vMELJyk6bTg+2EnV76fANhGyhjeQ4ek0Ko='
WHERE
key_id = '8bd168a6fedfdaaf82fb3d8f3ed8145dafa6f3993854b65790bb71a9630e4343'
AND (
token = 'D6N6O0gk+vMELJyk6bTg+2EnV76fANhGyhjeQ4ek0Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)