UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0QwmZCtu4tb7i+LGKYGo6EUNkj2zlkDSsHZFy2ejLuU=' 
WHERE 
  key_id = 'cb1bcb7263dba3e2581ac7c89c1f6a3fa25c080edb82881f7335dcba24634e83' 
  AND (
    token = '0QwmZCtu4tb7i+LGKYGo6EUNkj2zlkDSsHZFy2ejLuU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037